Understanding how Meridian works with SQL Server

Meridian works with SQL Server using two intermediate Meridian components:

• Object cache (<DatabaseEngine>SQL.dll): A database-dependent cache that optimizes queries to SQL Server.
• SQLIO (HTSQLIO.dll): A SQL Server-specific component that interfaces between the object cache and SQL Server.

The relationships between all of these components are illustrated in the following figure.

When a Meridian client sends or requests data from the Meridian application server, the EDM Server service communicates with its object cache, which in turn communicates with SQLIO, which then communicates with SQL Server on the SQL Server computer.

Warning    Do not change the properties of a SQL Server database that is used by Meridian. Especially do not clear the Unrestricted file growth options for Maximum file size for either the data files or the transaction log because when the maximum size of the log file is reached, SQL Server cannot write to the database any more, as it is full.